Research Assignment
Data: http://www.sports-reference.com/cfb/years/2002-standings.html (choose CSV).
1. Data & Statistics (Save your spreadsheet by your first-last name and assignment number.)
a. Submit a Microsoft Excel spreadsheet with the raw data in the Dropbox for Research Assignment #3 on ICON for the NCAA FBS “league” for 2002 through 2013
seasons. (10 points)
b. Calculate the Noll-Scully for each season for the “league” for each season. (40 points)
•??The Noll-Scully formula can be found in “The Short Supply of Tall People” paper.
•??If a season has teams that played a different numbers of games, take an average of ?the number of games played (N) for that year, by
averaging all the games played in ?that season.
•??Step-by-step guide to calculating the Noll-Scully Competitive Balance.
2. Written Explanation (Submit your Microsoft Word document with your written explanations).
a. For the NCAA FBS calculate the average Noll-Scully over the 2002-2013 seasons. (10 ?points)
b. Compare that with the results presented in The Wages of Wins for (American) football: ?Do you think the average is similar or different to the NFL and AFL? (10
points)
c. Based on your results, do you agree with Berri, Schmidt and Brook as to why leagues ?have similar levels of competitive balance? Why or why not? (30 points)
[From your answers in 2a & b, if you think the Noll-Scully is similar, then explain why it is similar (Berri, Schmidt & Brook are right or wrong because …); from
your answers in 2a & b, if you think the Noll-Scully is different, then explain why it is different (Berri, Schmidt & Brook are right or wrong because …).